Overview
Brought to you by YData
Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 7253 |
| Missing cells | 7628 |
| Missing cells (%) | 7.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 793.4 KiB |
| Average record size in memory | 112.0 B |
Variable types
| Numeric | 5 |
|---|---|
| Text | 5 |
| Categorical | 4 |
Kilometers_Driven is highly overall correlated with Year | High correlation |
Price is highly overall correlated with Transmission | High correlation |
Transmission is highly overall correlated with Price | High correlation |
Year is highly overall correlated with Kilometers_Driven | High correlation |
Fuel_Type is highly imbalanced (53.6%) | Imbalance |
Owner_Type is highly imbalanced (61.0%) | Imbalance |
New_Price has 6247 (86.1%) missing values | Missing |
Price has 1234 (17.0%) missing values | Missing |
Kilometers_Driven is highly skewed (γ1 = 61.58257466) | Skewed |
S.No. is uniformly distributed | Uniform |
S.No. has unique values | Unique |
Reproduction
| Analysis started | 2025-05-27 06:49:21.679651 |
|---|---|
| Analysis finished | 2025-05-27 06:49:26.335895 |
| Duration | 4.66 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
S.No.
Real number (ℝ)
Uniform  Unique 
| Distinct | 7253 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3626 |
| Minimum | 0 |
|---|---|
| Maximum | 7252 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 362.6 |
| Q1 | 1813 |
| median | 3626 |
| Q3 | 5439 |
| 95-th percentile | 6889.4 |
| Maximum | 7252 |
| Range | 7252 |
| Interquartile range (IQR) | 3626 |
Descriptive statistics
| Standard deviation | 2093.9051 |
|---|---|
| Coefficient of variation (CV) | 0.57746969 |
| Kurtosis | -1.2 |
| Mean | 3626 |
| Median Absolute Deviation (MAD) | 1813 |
| Skewness | 0 |
| Sum | 26299378 |
| Variance | 4384438.5 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 7252 | 1 | < 0.1% |
| 0 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 7236 | 1 | < 0.1% |
| 7235 | 1 | < 0.1% |
| 7234 | 1 | < 0.1% |
| 7233 | 1 | < 0.1% |
| 7232 | 1 | < 0.1% |
| Other values (7243) | 7243 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 7252 | 1 | |
| 7251 | 1 | |
| 7250 | 1 | |
| 7249 | 1 | |
| 7248 | 1 | |
| 7247 | 1 | |
| 7246 | 1 | |
| 7245 | 1 | |
| 7244 | 1 | |
| 7243 | 1 |
Name
Text
| Distinct | 2041 |
|---|---|
| Distinct (%) | 28.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.8 KiB |
Length
| Max length | 59 |
|---|---|
| Median length | 48 |
| Mean length | 26.15759 |
| Min length | 11 |
Unique
| Unique | 862 ? |
|---|---|
| Unique (%) | 11.9% |
Sample
| 1st row | Maruti Wagon R LXI CNG |
|---|---|
| 2nd row | Hyundai Creta 1.6 CRDi SX Option |
| 3rd row | Honda Jazz V |
| 4th row | Maruti Ertiga VDI |
| 5th row | Audi A4 New 2.0 TDI Multitronic |
| Value | Count | Frequency (%) |
| maruti | 1444 | 4.1% |
| hyundai | 1340 | 3.8% |
| honda | 743 | 2.1% |
| at | 655 | 1.9% |
| diesel | 609 | 1.7% |
| 1.2 | 521 | 1.5% |
| toyota | 507 | 1.4% |
| tdi | 479 | 1.4% |
| mt | 419 | 1.2% |
| swift | 418 | 1.2% |
| Other values (907) | 27958 |
Most occurring characters
| Value | Count | Frequency (%) |
| 27840 | 14.7% | |
| a | 11809 | 6.2% |
| i | 11426 | 6.0% |
| e | 9233 | 4.9% |
| t | 7952 | 4.2% |
| o | 7950 | 4.2% |
| n | 7822 | 4.1% |
| r | 7647 | 4.0% |
| u | 5214 | 2.7% |
| d | 4930 | 2.6% |
| Other values (59) | 87898 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 189721 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 27840 | 14.7% | |
| a | 11809 | 6.2% |
| i | 11426 | 6.0% |
| e | 9233 | 4.9% |
| t | 7952 | 4.2% |
| o | 7950 | 4.2% |
| n | 7822 | 4.1% |
| r | 7647 | 4.0% |
| u | 5214 | 2.7% |
| d | 4930 | 2.6% |
| Other values (59) | 87898 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 189721 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 27840 | 14.7% | |
| a | 11809 | 6.2% |
| i | 11426 | 6.0% |
| e | 9233 | 4.9% |
| t | 7952 | 4.2% |
| o | 7950 | 4.2% |
| n | 7822 | 4.1% |
| r | 7647 | 4.0% |
| u | 5214 | 2.7% |
| d | 4930 | 2.6% |
| Other values (59) | 87898 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 189721 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 27840 | 14.7% | |
| a | 11809 | 6.2% |
| i | 11426 | 6.0% |
| e | 9233 | 4.9% |
| t | 7952 | 4.2% |
| o | 7950 | 4.2% |
| n | 7822 | 4.1% |
| r | 7647 | 4.0% |
| u | 5214 | 2.7% |
| d | 4930 | 2.6% |
| Other values (59) | 87898 |
Location
Categorical
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.8 KiB |
| Mumbai | |
|---|---|
| Hyderabad | |
| Coimbatore | |
| Kochi | |
| Pune | |
| Other values (6) |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 6.8470978 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mumbai |
|---|---|
| 2nd row | Pune |
| 3rd row | Chennai |
| 4th row | Chennai |
| 5th row | Coimbatore |
Common Values
| Value | Count | Frequency (%) |
| Mumbai | 949 | |
| Hyderabad | 876 | |
| Coimbatore | 772 | |
| Kochi | 772 | |
| Pune | 765 | |
| Delhi | 660 | |
| Kolkata | 654 | |
| Chennai | 591 | |
| Jaipur | 499 | |
| Bangalore | 440 |
Length
| Value | Count | Frequency (%) |
| mumbai | 949 | |
| hyderabad | 876 | |
| coimbatore | 772 | |
| kochi | 772 | |
| pune | 765 | |
| delhi | 660 | |
| kolkata | 654 | |
| chennai | 591 | |
| jaipur | 499 | |
| bangalore | 440 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 7301 | |
| e | 4379 | 8.8% |
| i | 4243 | 8.5% |
| o | 3410 | 6.9% |
| b | 2872 | 5.8% |
| r | 2587 | 5.2% |
| n | 2387 | 4.8% |
| d | 2302 | 4.6% |
| h | 2298 | 4.6% |
| u | 2213 | 4.5% |
| Other values (17) | 15670 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 49662 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 7301 | |
| e | 4379 | 8.8% |
| i | 4243 | 8.5% |
| o | 3410 | 6.9% |
| b | 2872 | 5.8% |
| r | 2587 | 5.2% |
| n | 2387 | 4.8% |
| d | 2302 | 4.6% |
| h | 2298 | 4.6% |
| u | 2213 | 4.5% |
| Other values (17) | 15670 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 49662 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 7301 | |
| e | 4379 | 8.8% |
| i | 4243 | 8.5% |
| o | 3410 | 6.9% |
| b | 2872 | 5.8% |
| r | 2587 | 5.2% |
| n | 2387 | 4.8% |
| d | 2302 | 4.6% |
| h | 2298 | 4.6% |
| u | 2213 | 4.5% |
| Other values (17) | 15670 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 49662 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 7301 | |
| e | 4379 | 8.8% |
| i | 4243 | 8.5% |
| o | 3410 | 6.9% |
| b | 2872 | 5.8% |
| r | 2587 | 5.2% |
| n | 2387 | 4.8% |
| d | 2302 | 4.6% |
| h | 2298 | 4.6% |
| u | 2213 | 4.5% |
| Other values (17) | 15670 |
Year
Real number (ℝ)
High correlation 
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2013.3654 |
| Minimum | 1996 |
|---|---|
| Maximum | 2019 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.8 KiB |
Quantile statistics
| Minimum | 1996 |
|---|---|
| 5-th percentile | 2007 |
| Q1 | 2011 |
| median | 2014 |
| Q3 | 2016 |
| 95-th percentile | 2018 |
| Maximum | 2019 |
| Range | 23 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.2544208 |
|---|---|
| Coefficient of variation (CV) | 0.0016164085 |
| Kurtosis | 0.91048764 |
| Mean | 2013.3654 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.83981615 |
| Sum | 14602939 |
| Variance | 10.591255 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2015 | 929 | |
| 2014 | 925 | |
| 2016 | 886 | |
| 2013 | 791 | |
| 2017 | 709 | |
| 2012 | 690 | |
| 2011 | 579 | |
| 2010 | 407 | |
| 2018 | 361 | 5.0% |
| 2009 | 252 | 3.5% |
| Other values (13) | 724 |
| Value | Count | Frequency (%) |
| 1996 | 1 | < 0.1% |
| 1998 | 4 | 0.1% |
| 1999 | 2 | < 0.1% |
| 2000 | 5 | 0.1% |
| 2001 | 8 | 0.1% |
| 2002 | 18 | 0.2% |
| 2003 | 20 | 0.3% |
| 2004 | 35 | 0.5% |
| 2005 | 68 | |
| 2006 | 89 |
| Value | Count | Frequency (%) |
| 2019 | 119 | 1.6% |
| 2018 | 361 | 5.0% |
| 2017 | 709 | |
| 2016 | 886 | |
| 2015 | 929 | |
| 2014 | 925 | |
| 2013 | 791 | |
| 2012 | 690 | |
| 2011 | 579 | |
| 2010 | 407 |
Kilometers_Driven
Real number (ℝ)
High correlation  Skewed 
| Distinct | 3660 |
|---|---|
| Distinct (%) | 50.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58699.063 |
| Minimum | 171 |
|---|---|
| Maximum | 6500000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.8 KiB |
Quantile statistics
| Minimum | 171 |
|---|---|
| 5-th percentile | 13017.6 |
| Q1 | 34000 |
| median | 53416 |
| Q3 | 73000 |
| 95-th percentile | 120241.8 |
| Maximum | 6500000 |
| Range | 6499829 |
| Interquartile range (IQR) | 39000 |
Descriptive statistics
| Standard deviation | 84427.721 |
|---|---|
| Coefficient of variation (CV) | 1.4383146 |
| Kurtosis | 4674.734 |
| Mean | 58699.063 |
| Median Absolute Deviation (MAD) | 19584 |
| Skewness | 61.582575 |
| Sum | 4.257443 × 108 |
| Variance | 7.12804 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 60000 | 96 | 1.3% |
| 65000 | 86 | 1.2% |
| 45000 | 86 | 1.2% |
| 70000 | 77 | 1.1% |
| 50000 | 72 | 1.0% |
| 55000 | 66 | 0.9% |
| 75000 | 64 | 0.9% |
| 35000 | 62 | 0.9% |
| 52000 | 62 | 0.9% |
| 80000 | 62 | 0.9% |
| Other values (3650) | 6520 |
| Value | Count | Frequency (%) |
| 171 | 1 | < 0.1% |
| 600 | 1 | < 0.1% |
| 1000 | 11 | |
| 1001 | 4 | 0.1% |
| 1011 | 1 | < 0.1% |
| 1015 | 1 | < 0.1% |
| 1048 | 1 | < 0.1% |
| 1261 | 1 | < 0.1% |
| 1331 | 1 | < 0.1% |
| 1400 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6500000 | 1 | |
| 775000 | 1 | |
| 720000 | 1 | |
| 620000 | 1 | |
| 480000 | 2 | |
| 445000 | 1 | |
| 350000 | 1 | |
| 300000 | 1 | |
| 299322 | 1 | |
| 290000 | 1 |
Fuel_Type
Categorical
Imbalance 
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.8 KiB |
| Diesel | |
|---|---|
| Petrol | |
| CNG | 62 |
| LPG | 12 |
| Electric | 2 |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 5.9699435 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CNG |
|---|---|
| 2nd row | Diesel |
| 3rd row | Petrol |
| 4th row | Diesel |
| 5th row | Diesel |
Common Values
| Value | Count | Frequency (%) |
| Diesel | 3852 | |
| Petrol | 3325 | |
| CNG | 62 | 0.9% |
| LPG | 12 | 0.2% |
| Electric | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| diesel | 3852 | |
| petrol | 3325 | |
| cng | 62 | 0.9% |
| lpg | 12 | 0.2% |
| electric | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 11031 | |
| l | 7179 | |
| i | 3854 | 8.9% |
| D | 3852 | 8.9% |
| s | 3852 | 8.9% |
| P | 3337 | 7.7% |
| t | 3327 | 7.7% |
| r | 3327 | 7.7% |
| o | 3325 | 7.7% |
| G | 74 | 0.2% |
| Other values (5) | 142 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 43300 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 11031 | |
| l | 7179 | |
| i | 3854 | 8.9% |
| D | 3852 | 8.9% |
| s | 3852 | 8.9% |
| P | 3337 | 7.7% |
| t | 3327 | 7.7% |
| r | 3327 | 7.7% |
| o | 3325 | 7.7% |
| G | 74 | 0.2% |
| Other values (5) | 142 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 43300 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 11031 | |
| l | 7179 | |
| i | 3854 | 8.9% |
| D | 3852 | 8.9% |
| s | 3852 | 8.9% |
| P | 3337 | 7.7% |
| t | 3327 | 7.7% |
| r | 3327 | 7.7% |
| o | 3325 | 7.7% |
| G | 74 | 0.2% |
| Other values (5) | 142 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 43300 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 11031 | |
| l | 7179 | |
| i | 3854 | 8.9% |
| D | 3852 | 8.9% |
| s | 3852 | 8.9% |
| P | 3337 | 7.7% |
| t | 3327 | 7.7% |
| r | 3327 | 7.7% |
| o | 3325 | 7.7% |
| G | 74 | 0.2% |
| Other values (5) | 142 | 0.3% |
Transmission
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.8 KiB |
| Manual | |
|---|---|
| Automatic |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 6.8475114 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Manual |
|---|---|
| 2nd row | Manual |
| 3rd row | Manual |
| 4th row | Manual |
| 5th row | Automatic |
Common Values
| Value | Count | Frequency (%) |
| Manual | 5204 | |
| Automatic | 2049 | 28.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| manual | 5204 | |
| automatic | 2049 | 28.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 12457 | |
| u | 7253 | |
| M | 5204 | |
| n | 5204 | |
| l | 5204 | |
| t | 4098 | 8.3% |
| A | 2049 | 4.1% |
| o | 2049 | 4.1% |
| m | 2049 | 4.1% |
| i | 2049 | 4.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 49665 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 12457 | |
| u | 7253 | |
| M | 5204 | |
| n | 5204 | |
| l | 5204 | |
| t | 4098 | 8.3% |
| A | 2049 | 4.1% |
| o | 2049 | 4.1% |
| m | 2049 | 4.1% |
| i | 2049 | 4.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 49665 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 12457 | |
| u | 7253 | |
| M | 5204 | |
| n | 5204 | |
| l | 5204 | |
| t | 4098 | 8.3% |
| A | 2049 | 4.1% |
| o | 2049 | 4.1% |
| m | 2049 | 4.1% |
| i | 2049 | 4.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 49665 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 12457 | |
| u | 7253 | |
| M | 5204 | |
| n | 5204 | |
| l | 5204 | |
| t | 4098 | 8.3% |
| A | 2049 | 4.1% |
| o | 2049 | 4.1% |
| m | 2049 | 4.1% |
| i | 2049 | 4.1% |
Owner_Type
Categorical
Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.8 KiB |
| First | |
|---|---|
| Second | |
| Third | 137 |
| Fourth & Above | 12 |
Length
| Max length | 14 |
|---|---|
| Median length | 5 |
| Mean length | 5.1737212 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | First |
|---|---|
| 2nd row | First |
| 3rd row | First |
| 4th row | First |
| 5th row | Second |
Common Values
| Value | Count | Frequency (%) |
| First | 5952 | |
| Second | 1152 | 15.9% |
| Third | 137 | 1.9% |
| Fourth & Above | 12 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| first | 5952 | |
| second | 1152 | 15.8% |
| third | 137 | 1.9% |
| fourth | 12 | 0.2% |
| 12 | 0.2% | |
| above | 12 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 6101 | |
| i | 6089 | |
| F | 5964 | |
| t | 5964 | |
| s | 5952 | |
| d | 1289 | 3.4% |
| o | 1176 | 3.1% |
| e | 1164 | 3.1% |
| S | 1152 | 3.1% |
| c | 1152 | 3.1% |
| Other values (9) | 1522 | 4.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 37525 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 6101 | |
| i | 6089 | |
| F | 5964 | |
| t | 5964 | |
| s | 5952 | |
| d | 1289 | 3.4% |
| o | 1176 | 3.1% |
| e | 1164 | 3.1% |
| S | 1152 | 3.1% |
| c | 1152 | 3.1% |
| Other values (9) | 1522 | 4.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 37525 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 6101 | |
| i | 6089 | |
| F | 5964 | |
| t | 5964 | |
| s | 5952 | |
| d | 1289 | 3.4% |
| o | 1176 | 3.1% |
| e | 1164 | 3.1% |
| S | 1152 | 3.1% |
| c | 1152 | 3.1% |
| Other values (9) | 1522 | 4.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 37525 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 6101 | |
| i | 6089 | |
| F | 5964 | |
| t | 5964 | |
| s | 5952 | |
| d | 1289 | 3.4% |
| o | 1176 | 3.1% |
| e | 1164 | 3.1% |
| S | 1152 | 3.1% |
| c | 1152 | 3.1% |
| Other values (9) | 1522 | 4.1% |
Mileage
Text
| Distinct | 450 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 56.8 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 9.3970487 |
| Min length | 8 |
Unique
| Unique | 60 ? |
|---|---|
| Unique (%) | 0.8% |
Sample
| 1st row | 26.6 km/kg |
|---|---|
| 2nd row | 19.67 kmpl |
| 3rd row | 18.2 kmpl |
| 4th row | 20.77 kmpl |
| 5th row | 15.2 kmpl |
| Value | Count | Frequency (%) |
| kmpl | 7177 | |
| 17.0 | 208 | 1.4% |
| 18.9 | 201 | 1.4% |
| 18.6 | 144 | 1.0% |
| 21.1 | 107 | 0.7% |
| 20.36 | 105 | 0.7% |
| 17.8 | 98 | 0.7% |
| 18.0 | 89 | 0.6% |
| 12.8 | 87 | 0.6% |
| 18.5 | 86 | 0.6% |
| Other values (430) | 6200 |
Most occurring characters
| Value | Count | Frequency (%) |
| k | 7325 | |
| . | 7251 | |
| 7251 | ||
| m | 7251 | |
| l | 7177 | |
| p | 7177 | |
| 1 | 6371 | |
| 2 | 3941 | 5.8% |
| 0 | 2224 | 3.3% |
| 7 | 1968 | 2.9% |
| Other values (8) | 10202 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 68138 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| k | 7325 | |
| . | 7251 | |
| 7251 | ||
| m | 7251 | |
| l | 7177 | |
| p | 7177 | |
| 1 | 6371 | |
| 2 | 3941 | 5.8% |
| 0 | 2224 | 3.3% |
| 7 | 1968 | 2.9% |
| Other values (8) | 10202 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 68138 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| k | 7325 | |
| . | 7251 | |
| 7251 | ||
| m | 7251 | |
| l | 7177 | |
| p | 7177 | |
| 1 | 6371 | |
| 2 | 3941 | 5.8% |
| 0 | 2224 | 3.3% |
| 7 | 1968 | 2.9% |
| Other values (8) | 10202 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 68138 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| k | 7325 | |
| . | 7251 | |
| 7251 | ||
| m | 7251 | |
| l | 7177 | |
| p | 7177 | |
| 1 | 6371 | |
| 2 | 3941 | 5.8% |
| 0 | 2224 | 3.3% |
| 7 | 1968 | 2.9% |
| Other values (8) | 10202 |
Engine
Text
| Distinct | 150 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 46 |
| Missing (%) | 0.6% |
| Memory size | 56.8 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.9006521 |
| Min length | 5 |
Unique
| Unique | 23 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | 998 CC |
|---|---|
| 2nd row | 1582 CC |
| 3rd row | 1199 CC |
| 4th row | 1248 CC |
| 5th row | 1968 CC |
| Value | Count | Frequency (%) |
| cc | 7207 | |
| 1197 | 732 | 5.1% |
| 1248 | 610 | 4.2% |
| 1498 | 370 | 2.6% |
| 998 | 309 | 2.1% |
| 1198 | 281 | 1.9% |
| 2179 | 278 | 1.9% |
| 1497 | 273 | 1.9% |
| 1968 | 266 | 1.8% |
| 1995 | 212 | 1.5% |
| Other values (141) | 3876 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 14414 | |
| 1 | 7427 | |
| 7207 | ||
| 9 | 6571 | |
| 8 | 3014 | 6.1% |
| 4 | 2585 | 5.2% |
| 2 | 2461 | 4.9% |
| 7 | 2056 | 4.1% |
| 6 | 1468 | 3.0% |
| 3 | 1144 | 2.3% |
| Other values (2) | 1386 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 49733 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 14414 | |
| 1 | 7427 | |
| 7207 | ||
| 9 | 6571 | |
| 8 | 3014 | 6.1% |
| 4 | 2585 | 5.2% |
| 2 | 2461 | 4.9% |
| 7 | 2056 | 4.1% |
| 6 | 1468 | 3.0% |
| 3 | 1144 | 2.3% |
| Other values (2) | 1386 | 2.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 49733 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 14414 | |
| 1 | 7427 | |
| 7207 | ||
| 9 | 6571 | |
| 8 | 3014 | 6.1% |
| 4 | 2585 | 5.2% |
| 2 | 2461 | 4.9% |
| 7 | 2056 | 4.1% |
| 6 | 1468 | 3.0% |
| 3 | 1144 | 2.3% |
| Other values (2) | 1386 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 49733 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 14414 | |
| 1 | 7427 | |
| 7207 | ||
| 9 | 6571 | |
| 8 | 3014 | 6.1% |
| 4 | 2585 | 5.2% |
| 2 | 2461 | 4.9% |
| 7 | 2056 | 4.1% |
| 6 | 1468 | 3.0% |
| 3 | 1144 | 2.3% |
| Other values (2) | 1386 | 2.8% |
Power
Text
| Distinct | 386 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 46 |
| Missing (%) | 0.6% |
| Memory size | 56.8 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 7.9353406 |
| Min length | 6 |
Unique
| Unique | 64 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | 58.16 bhp |
|---|---|
| 2nd row | 126.2 bhp |
| 3rd row | 88.7 bhp |
| 4th row | 88.76 bhp |
| 5th row | 140.8 bhp |
| Value | Count | Frequency (%) |
| bhp | 7207 | |
| 74 | 280 | 1.9% |
| 98.6 | 166 | 1.2% |
| 73.9 | 152 | 1.1% |
| 140 | 142 | 1.0% |
| null | 129 | 0.9% |
| 78.9 | 128 | 0.9% |
| 67.1 | 126 | 0.9% |
| 67.04 | 125 | 0.9% |
| 82 | 124 | 0.9% |
| Other values (377) | 5835 |
Most occurring characters
| Value | Count | Frequency (%) |
| b | 7207 | |
| 7207 | ||
| h | 7207 | |
| p | 7207 | |
| . | 4464 | |
| 1 | 4411 | |
| 8 | 3840 | |
| 7 | 2779 | 4.9% |
| 3 | 2129 | 3.7% |
| 6 | 2079 | 3.6% |
| Other values (8) | 8660 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 57190 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| b | 7207 | |
| 7207 | ||
| h | 7207 | |
| p | 7207 | |
| . | 4464 | |
| 1 | 4411 | |
| 8 | 3840 | |
| 7 | 2779 | 4.9% |
| 3 | 2129 | 3.7% |
| 6 | 2079 | 3.6% |
| Other values (8) | 8660 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 57190 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| b | 7207 | |
| 7207 | ||
| h | 7207 | |
| p | 7207 | |
| . | 4464 | |
| 1 | 4411 | |
| 8 | 3840 | |
| 7 | 2779 | 4.9% |
| 3 | 2129 | 3.7% |
| 6 | 2079 | 3.6% |
| Other values (8) | 8660 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 57190 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| b | 7207 | |
| 7207 | ||
| h | 7207 | |
| p | 7207 | |
| . | 4464 | |
| 1 | 4411 | |
| 8 | 3840 | |
| 7 | 2779 | 4.9% |
| 3 | 2129 | 3.7% |
| 6 | 2079 | 3.6% |
| Other values (8) | 8660 |
Seats
Real number (ℝ)
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 53 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.2797222 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 5 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.81165967 |
|---|---|
| Coefficient of variation (CV) | 0.15373151 |
| Kurtosis | 4.7034289 |
| Mean | 5.2797222 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.902262 |
| Sum | 38014 |
| Variance | 0.65879142 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 6047 | |
| 7 | 796 | 11.0% |
| 8 | 170 | 2.3% |
| 4 | 119 | 1.6% |
| 6 | 38 | 0.5% |
| 2 | 18 | 0.2% |
| 10 | 8 | 0.1% |
| 9 | 3 | < 0.1% |
| 0 | 1 | < 0.1% |
| (Missing) | 53 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 2 | 18 | 0.2% |
| 4 | 119 | 1.6% |
| 5 | 6047 | |
| 6 | 38 | 0.5% |
| 7 | 796 | 11.0% |
| 8 | 170 | 2.3% |
| 9 | 3 | < 0.1% |
| 10 | 8 | 0.1% |
| Value | Count | Frequency (%) |
| 10 | 8 | 0.1% |
| 9 | 3 | < 0.1% |
| 8 | 170 | 2.3% |
| 7 | 796 | 11.0% |
| 6 | 38 | 0.5% |
| 5 | 6047 | |
| 4 | 119 | 1.6% |
| 2 | 18 | 0.2% |
| 0 | 1 | < 0.1% |
New_Price
Text
Missing 
| Distinct | 625 |
|---|---|
| Distinct (%) | 62.1% |
| Missing | 6247 |
| Missing (%) | 86.1% |
| Memory size | 56.8 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.4194831 |
| Min length | 4 |
Unique
| Unique | 391 ? |
|---|---|
| Unique (%) | 38.9% |
Sample
| 1st row | 8.61 Lakh |
|---|---|
| 2nd row | 21 Lakh |
| 3rd row | 10.65 Lakh |
| 4th row | 32.01 Lakh |
| 5th row | 47.87 Lakh |
| Value | Count | Frequency (%) |
| lakh | 986 | |
| cr | 20 | 1.0% |
| 95.13 | 6 | 0.3% |
| 63.71 | 6 | 0.3% |
| 33.36 | 6 | 0.3% |
| 4.78 | 6 | 0.3% |
| 5.04 | 5 | 0.2% |
| 15.05 | 5 | 0.2% |
| 4.09 | 5 | 0.2% |
| 9.12 | 5 | 0.2% |
| Other values (617) | 962 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1006 | ||
| . | 989 | |
| h | 986 | |
| L | 986 | |
| k | 986 | |
| a | 986 | |
| 1 | 627 | 6.6% |
| 4 | 386 | 4.1% |
| 5 | 371 | 3.9% |
| 7 | 356 | 3.8% |
| Other values (8) | 1797 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9476 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1006 | ||
| . | 989 | |
| h | 986 | |
| L | 986 | |
| k | 986 | |
| a | 986 | |
| 1 | 627 | 6.6% |
| 4 | 386 | 4.1% |
| 5 | 371 | 3.9% |
| 7 | 356 | 3.8% |
| Other values (8) | 1797 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9476 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1006 | ||
| . | 989 | |
| h | 986 | |
| L | 986 | |
| k | 986 | |
| a | 986 | |
| 1 | 627 | 6.6% |
| 4 | 386 | 4.1% |
| 5 | 371 | 3.9% |
| 7 | 356 | 3.8% |
| Other values (8) | 1797 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9476 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1006 | ||
| . | 989 | |
| h | 986 | |
| L | 986 | |
| k | 986 | |
| a | 986 | |
| 1 | 627 | 6.6% |
| 4 | 386 | 4.1% |
| 5 | 371 | 3.9% |
| 7 | 356 | 3.8% |
| Other values (8) | 1797 |
Price
Real number (ℝ)
High correlation  Missing 
| Distinct | 1373 |
|---|---|
| Distinct (%) | 22.8% |
| Missing | 1234 |
| Missing (%) | 17.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.4794684 |
| Minimum | 0.44 |
|---|---|
| Maximum | 160 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.8 KiB |
Quantile statistics
| Minimum | 0.44 |
|---|---|
| 5-th percentile | 1.7 |
| Q1 | 3.5 |
| median | 5.64 |
| Q3 | 9.95 |
| 95-th percentile | 32.446 |
| Maximum | 160 |
| Range | 159.56 |
| Interquartile range (IQR) | 6.45 |
Descriptive statistics
| Standard deviation | 11.187917 |
|---|---|
| Coefficient of variation (CV) | 1.1802262 |
| Kurtosis | 17.092202 |
| Mean | 9.4794684 |
| Median Absolute Deviation (MAD) | 2.62 |
| Skewness | 3.335232 |
| Sum | 57056.92 |
| Variance | 125.16949 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.5 | 88 | 1.2% |
| 5.5 | 84 | 1.2% |
| 3.5 | 82 | 1.1% |
| 4.25 | 73 | 1.0% |
| 3.25 | 71 | 1.0% |
| 3 | 68 | 0.9% |
| 6.5 | 64 | 0.9% |
| 2.5 | 63 | 0.9% |
| 4 | 56 | 0.8% |
| 4.75 | 53 | 0.7% |
| Other values (1363) | 5317 | |
| (Missing) | 1234 | 17.0% |
| Value | Count | Frequency (%) |
| 0.44 | 1 | < 0.1% |
| 0.45 | 3 | |
| 0.5 | 2 | |
| 0.51 | 1 | < 0.1% |
| 0.53 | 2 | |
| 0.55 | 3 | |
| 0.6 | 2 | |
| 0.63 | 1 | < 0.1% |
| 0.65 | 2 | |
| 0.69 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 160 | 1 | |
| 120 | 1 | |
| 100 | 1 | |
| 97.07 | 1 | |
| 93.67 | 1 | |
| 93 | 1 | |
| 90 | 1 | |
| 85 | 1 | |
| 83.96 | 1 | |
| 79 | 2 |
Interactions
Correlations
| Fuel_Type | Kilometers_Driven | Location | Owner_Type | Price | S.No. | Seats | Transmission | Year | |
|---|---|---|---|---|---|---|---|---|---|
| Fuel_Type | 1.000 | 0.000 | 0.093 | 0.023 | 0.148 | 0.019 | 0.160 | 0.150 | 0.095 |
| Kilometers_Driven | 0.000 | 1.000 | 0.008 | 0.000 | -0.215 | 0.004 | 0.191 | 0.012 | -0.552 |
| Location | 0.093 | 0.008 | 1.000 | 0.160 | 0.074 | 0.000 | 0.026 | 0.195 | 0.136 |
| Owner_Type | 0.023 | 0.000 | 0.160 | 1.000 | 0.058 | 0.000 | 0.046 | 0.007 | 0.251 |
| Price | 0.148 | -0.215 | 0.074 | 0.058 | 1.000 | -0.007 | 0.221 | 0.595 | 0.491 |
| S.No. | 0.019 | 0.004 | 0.000 | 0.000 | -0.007 | 1.000 | -0.009 | 0.000 | 0.008 |
| Seats | 0.160 | 0.191 | 0.026 | 0.046 | 0.221 | -0.009 | 1.000 | 0.146 | 0.031 |
| Transmission | 0.150 | 0.012 | 0.195 | 0.007 | 0.595 | 0.000 | 0.146 | 1.000 | 0.101 |
| Year | 0.095 | -0.552 | 0.136 | 0.251 | 0.491 | 0.008 | 0.031 | 0.101 | 1.000 |
Missing values
Sample
| S.No. | Name | Location | Year | Kilometers_Driven | Fuel_Type | Transmission | Owner_Type | Mileage | Engine | Power | Seats | New_Price | Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | Maruti Wagon R LXI CNG | Mumbai | 2010 | 72000 | CNG | Manual | First | 26.6 km/kg | 998 CC | 58.16 bhp | 5.0 | NaN | 1.75 |
| 1 | 1 | Hyundai Creta 1.6 CRDi SX Option | Pune | 2015 | 41000 | Diesel | Manual | First | 19.67 kmpl | 1582 CC | 126.2 bhp | 5.0 | NaN | 12.50 |
| 2 | 2 | Honda Jazz V | Chennai | 2011 | 46000 | Petrol | Manual | First | 18.2 kmpl | 1199 CC | 88.7 bhp | 5.0 | 8.61 Lakh | 4.50 |
| 3 | 3 | Maruti Ertiga VDI | Chennai | 2012 | 87000 | Diesel | Manual | First | 20.77 kmpl | 1248 CC | 88.76 bhp | 7.0 | NaN | 6.00 |
| 4 | 4 | Audi A4 New 2.0 TDI Multitronic | Coimbatore | 2013 | 40670 | Diesel | Automatic | Second | 15.2 kmpl | 1968 CC | 140.8 bhp | 5.0 | NaN | 17.74 |
| 5 | 5 | Hyundai EON LPG Era Plus Option | Hyderabad | 2012 | 75000 | LPG | Manual | First | 21.1 km/kg | 814 CC | 55.2 bhp | 5.0 | NaN | 2.35 |
| 6 | 6 | Nissan Micra Diesel XV | Jaipur | 2013 | 86999 | Diesel | Manual | First | 23.08 kmpl | 1461 CC | 63.1 bhp | 5.0 | NaN | 3.50 |
| 7 | 7 | Toyota Innova Crysta 2.8 GX AT 8S | Mumbai | 2016 | 36000 | Diesel | Automatic | First | 11.36 kmpl | 2755 CC | 171.5 bhp | 8.0 | 21 Lakh | 17.50 |
| 8 | 8 | Volkswagen Vento Diesel Comfortline | Pune | 2013 | 64430 | Diesel | Manual | First | 20.54 kmpl | 1598 CC | 103.6 bhp | 5.0 | NaN | 5.20 |
| 9 | 9 | Tata Indica Vista Quadrajet LS | Chennai | 2012 | 65932 | Diesel | Manual | Second | 22.3 kmpl | 1248 CC | 74 bhp | 5.0 | NaN | 1.95 |
| S.No. | Name | Location | Year | Kilometers_Driven | Fuel_Type | Transmission | Owner_Type | Mileage | Engine | Power | Seats | New_Price | Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7243 | 7243 | Renault Duster 85PS Diesel RxL | Chennai | 2015 | 70000 | Diesel | Manual | First | 19.87 kmpl | 1461 CC | 83.8 bhp | 5.0 | NaN | NaN |
| 7244 | 7244 | Chevrolet Aveo 1.4 LS | Pune | 2009 | 45463 | Petrol | Manual | First | 14.49 kmpl | 1399 CC | 92.7 bhp | 5.0 | NaN | NaN |
| 7245 | 7245 | Honda Amaze S i-Vtech | Kochi | 2015 | 44776 | Petrol | Manual | First | 18.0 kmpl | 1198 CC | 86.7 bhp | 5.0 | NaN | NaN |
| 7246 | 7246 | Hyundai Grand i10 AT Asta | Coimbatore | 2016 | 18242 | Petrol | Automatic | First | 18.9 kmpl | 1197 CC | 82 bhp | 5.0 | NaN | NaN |
| 7247 | 7247 | Hyundai EON D Lite Plus | Coimbatore | 2015 | 21190 | Petrol | Manual | First | 21.1 kmpl | 814 CC | 55.2 bhp | 5.0 | NaN | NaN |
| 7248 | 7248 | Volkswagen Vento Diesel Trendline | Hyderabad | 2011 | 89411 | Diesel | Manual | First | 20.54 kmpl | 1598 CC | 103.6 bhp | 5.0 | NaN | NaN |
| 7249 | 7249 | Volkswagen Polo GT TSI | Mumbai | 2015 | 59000 | Petrol | Automatic | First | 17.21 kmpl | 1197 CC | 103.6 bhp | 5.0 | NaN | NaN |
| 7250 | 7250 | Nissan Micra Diesel XV | Kolkata | 2012 | 28000 | Diesel | Manual | First | 23.08 kmpl | 1461 CC | 63.1 bhp | 5.0 | NaN | NaN |
| 7251 | 7251 | Volkswagen Polo GT TSI | Pune | 2013 | 52262 | Petrol | Automatic | Third | 17.2 kmpl | 1197 CC | 103.6 bhp | 5.0 | NaN | NaN |
| 7252 | 7252 | Mercedes-Benz E-Class 2009-2013 E 220 CDI Avantgarde | Kochi | 2014 | 72443 | Diesel | Automatic | First | 10.0 kmpl | 2148 CC | 170 bhp | 5.0 | NaN | NaN |